/*
 Navicat Premium Dump SQL

 Source Server         : localmysql
 Source Server Type    : MySQL
 Source Server Version : 90001 (9.0.1)
 Source Host           : localhost:3306
 Source Schema         : db01

 Target Server Type    : MySQL
 Target Server Version : 90001 (9.0.1)
 File Encoding         : 65001

 Date: 30/09/2024 15:48:00
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for tb_dept
-- ----------------------------
DROP TABLE IF EXISTS `tb_dept`;
CREATE TABLE `tb_dept` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT 'ID 主键',
  `name` varchar(10) NOT NULL COMMENT '部门名称',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `name` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='部门表';

-- ----------------------------
-- Records of tb_dept
-- ----------------------------
BEGIN;
INSERT INTO `tb_dept` (`id`, `name`, `create_time`, `update_time`) VALUES (2, '教研部', '2024-09-27 16:35:54', '2024-09-27 16:35:56');
INSERT INTO `tb_dept` (`id`, `name`, `create_time`, `update_time`) VALUES (3, '咨询部', '2024-09-27 16:36:15', '2024-09-27 16:36:17');
INSERT INTO `tb_dept` (`id`, `name`, `create_time`, `update_time`) VALUES (4, '就业部', '2024-09-27 16:36:30', '2024-09-27 16:36:31');
INSERT INTO `tb_dept` (`id`, `name`, `create_time`, `update_time`) VALUES (5, '学工部', '2024-09-29 17:31:35', NULL);
COMMIT;

-- ----------------------------
-- Table structure for tb_emp
-- ----------------------------
DROP TABLE IF EXISTS `tb_emp`;
CREATE TABLE `tb_emp` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '唯一标识',
  `username` varchar(20) NOT NULL COMMENT '用户名',
  `password` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '123456' COMMENT '密码',
  `name` varchar(10) NOT NULL COMMENT '姓名',
  `gender` tinyint unsigned NOT NULL COMMENT '性别 1男 2女',
  `image` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '图像 url',
  `entrydate` date DEFAULT NULL COMMENT '入职日期',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `dept_id` int NOT NULL COMMENT '部门ID',
  PRIMARY KEY (`id`),
  KEY `tb_emp___fk_dept_id` (`dept_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='员工表';

-- ----------------------------
-- Records of tb_emp
-- ----------------------------
BEGIN;
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (4, 'user1', 'e10adc3949ba59abbe56e057f20f883e', '张伟', 1, 'http://example.com/image1.jpg', '2023-06-18', '2024-09-27 15:27:31', '2024-09-27 15:27:31', 1);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (5, 'user2', 'e10adc3949ba59abbe56e057f20f883e', '李娜', 2, 'http://example.com/image2.jpg', '2023-02-15', '2024-09-27 15:27:31', '2024-09-27 15:27:31', 2);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (6, 'user3', 'e10adc3949ba59abbe56e057f20f883e', '王强', 1, NULL, '2023-03-20', '2024-09-27 15:27:31', '2024-09-27 15:27:31', 3);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (7, 'user4', 'e10adc3949ba59abbe56e057f20f883e', '赵敏', 2, 'http://example.com/image4.jpg', '2023-04-10', '2024-09-27 15:27:31', '2024-09-27 15:27:31', 4);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (8, 'user5', 'e10adc3949ba59abbe56e057f20f883e', '刘洋', 1, 'http://example.com/image5.jpg', '2023-05-05', '2024-09-27 15:27:31', '2024-09-27 15:27:31', 2);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (9, 'user6', 'e10adc3949ba59abbe56e057f20f883e', '孙丽', 2, NULL, '2023-06-18', '2024-09-27 15:27:31', '2024-09-27 15:27:31', 1);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (10, 'user7', 'e10adc3949ba59abbe56e057f20f883e', '周杰', 1, 'http://example.com/image7.jpg', '2023-07-22', '2024-09-27 15:27:31', '2024-09-27 15:27:31', 4);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (11, 'user8', 'e10adc3949ba59abbe56e057f20f883e', '吴彤', 2, 'http://example.com/image8.jpg', '2023-08-08', '2024-09-27 15:27:31', '2024-09-27 15:27:31', 3);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (12, 'user9', 'e10adc3949ba59abbe56e057f20f883e', '陈龙', 1, 'http://example.com/image9.jpg', '2023-09-15', '2024-09-27 15:27:31', '2024-09-27 15:27:31', 2);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (13, 'user10', 'e10adc3949ba59abbe56e057f20f883e', '林芳', 2, 'http://example.com/image10.jpg', '2023-10-05', '2024-09-27 15:27:31', '2024-09-27 15:27:31', 1);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (14, 'user11', 'e10adc3949ba59abbe56e057f20f883e', '郭峰', 1, NULL, '2023-01-12', '2024-09-27 15:27:31', '2024-09-27 15:27:31', 3);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (15, 'user12', 'e10adc3949ba59abbe56e057f20f883e', '唐静', 2, 'http://example.com/image12.jpg', '2023-02-20', '2024-09-27 15:27:31', '2024-09-27 15:27:31', 4);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (16, 'user13', 'e10adc3949ba59abbe56e057f20f883e', '杨帆', 1, 'http://example.com/image13.jpg', '2023-03-25', '2024-09-27 15:27:31', '2024-09-27 15:27:31', 2);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (17, 'user14', 'e10adc3949ba59abbe56e057f20f883e', '何琳', 2, 'http://example.com/image14.jpg', '2023-04-15', '2024-09-27 15:27:31', '2024-09-27 15:27:31', 1);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (18, 'user15', 'e10adc3949ba59abbe56e057f20f883e', '邓超', 1, 'http://example.com/image15.jpg', '2023-05-25', '2024-09-27 15:27:31', '2024-09-27 15:27:31', 3);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (19, 'user16', 'e10adc3949ba59abbe56e057f20f883e', '徐悦', 2, 'http://example.com/image16.jpg', '2023-06-10', '2024-09-27 15:27:31', '2024-09-27 15:27:31', 4);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (20, 'user17', 'e10adc3949ba59abbe56e057f20f883e', '丁宁', 1, NULL, '2023-07-05', '2024-09-27 15:27:31', '2024-09-27 15:27:31', 1);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (21, 'user18', 'e10adc3949ba59abbe56e057f20f883e', '彭菲', 2, 'http://example.com/image18.jpg', '2023-08-12', '2024-09-27 15:27:31', '2024-09-27 15:27:31', 2);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (30, 'user19', '123456789', '钱席', 1, NULL, '2023-08-02', '2024-09-30 14:19:45', NULL, 1);
INSERT INTO `tb_emp` (`id`, `username`, `password`, `name`, `gender`, `image`, `entrydate`, `create_time`, `update_time`, `dept_id`) VALUES (31, 'user20', '123', '李娜', 2, NULL, '2023-01-05', '2024-09-30 14:21:08', NULL, 2);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
